Problem Note 31982: When Converting Projects, Manual Groupings from Interactive Grouping node conversion might not be used
 |  |  |  |  |
When converting projects from SAS® Enterprise Miner™ 5.2 to SAS Enterprise Miner 5.3, the converted project might not be correct if the flow contains an Interactive Grouping node in which manual groupings were created. Even exporting the groupings data set will not correctly show the manual groupings.
There are no errors or warnings to indicate that the that the groupings data set was not used or that the converted project is not correct.
The new Interactive Grouping node will rerun the node and recreate all groupings because the groupings data set that is used by the Interactive Grouping node in SAS Enterprise Miner 5.3 requires an additional variable that is not found in the earlier version.
In order to convert a project that contains manual groupings in the Interactive Grouping node from 5.2 to 5.3, the groupings data set must be updated to contain the additional variable prior to performing the conversion. The Full Code tab above contains a sample program that manipulates the SAS Enterprise Miner 5.2 exported groupings data set to make it suitable for use in the Interactive Grouping node in SAS Enterprise Miner 5.3.
Note that this code is not production-level code, but it has been found to fix the issue.
After running the code, proceed as follows:
- Import the project into SAS Enterprise Miner 5.3
- Set the Import Grouping Data property to Yes
- Set the Import Data property to the updated groupings data set
- Run the Interactive Grouping node in SAS Enterprise Miner 5.3
The splits in the Interactive Grouping node should be the same as those in the imported project. Inspect these splits to verify the import has been successful.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Miner | Microsoft® Windows® for 64-Bit Itanium-based Systems | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP 64-bit Edition | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft® Windows® for x64 | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Advanced Server | 5.3 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Datacenter Server | 5.3 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 5.3 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 5.3 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows NT Workstation | 5.3 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled HP-UX | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| HP-UX IPF | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Linux | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Linux on Itanium | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Tru64 UNIX | 5.3 | 6.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
libname test 'c:\test'; ***you can specify the libname you desire;
%macro ign5253(dsin=,dsout=);
/*check if the input dataset was already converted */
data _null_;
set &dsin;
if binflag then do;
put " *** Export Grouping Dataset already converted for Enterprise Miner 5.3 using! ***";
put " *** Cannot proceed to execute the conversion data step ***";
abort 999;
end;
run;
/* create MISSING data set */
data dsmiss;
set &dsin;
if upcase(_split_value_)='MISSING';
if _split_value_="Missing" then _split_value_="MISSING";
if upcase(_split_value_) ^="MISSING" and _level_ = "INTERVAL" then binFlag=1;
else binFlag=0;
run;
/* run a sorting by variable name and group without MISSING split*/
proc sort data=&dsin(where=(upcase(_split_value_) ne 'MISSING')) out=&dsout;
by _variable_ _group_;
run;
/* generate new dataset for Enterprise Miner 5.3 excluding missing*/
data &dsout;
set &dsout;
by _variable_ _group_;
length binFlag 8;
if upcase(_split_value_) ^="MISSING" and _level_ = "INTERVAL" then binFlag=1;
else binFlag=0;
if _split_value_="Missing" then _split_value_="MISSING";
if last._variable_ and _level_ = "INTERVAL" then do;
output;
_split_value_=".";
_group_=_group_+1;
end;
output;
run;
/* add missing split*/
data &dsout;
set &dsout dsmiss;
run;
/* final sort*/
proc sort data=&dsout ;
by _variable_ _group_;
run;
%mend;
/* example to execute the macro
%ign5253(dsin=ap.Ign_exportgrouping,dsout=ap.newconv);
*/
/* SAS Institute Inc.
License Agreement for Corrective Code or Additional Functionality
SAS INSTITUTE INC. IS PROVIDING YOU WITH THE COMPUTER SOFTWARE CODE INCLUDED
WITH THIS AGREEMENT ("CODE") ON AN "AS IS" BASIS, AND AUTHORIZES YOU TO USE THE
CODE SUBJECT TO THE TERMS HEREOF. BY USING THE CODE, YOU AGREE TO THESE TERMS.
YOUR USE OF THE CODE IS AT YOUR OWN RISK. SAS INSTITUTE INC. MAKES NO
REPRESENTATION OR WARRANTY, EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO,
WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, NONINFRINGEMENT
AND TITLE, WITH RESPECT TO THE CODE.
The Code is intended to be used solely as part of a product ("Software") you
currently have licensed from SAS Institute Inc. or one of its subsidiaries or
authorized agents ("SAS"). The Code is designed to either correct an error in
the Software or to add functionality to the Software, but has not necessarily
been tested. Accordingly, SAS makes no representation or warranty that the Code
will operate error-free. SAS is under no obligation to maintain or support the
Code.
Neither SAS nor its licensors shall be liable to you or any third party for any
general, special, direct, indirect, consequential, incidental or other damages
whatsoever arising out of or related to your use or inability to use the Code,
even if SAS has been advised of the possibility of such damages.
Except as otherwise provided above, the Code is governed by the same agreement
that governs the Software. If you do not have an existing agreement with SAS
governing the Software, you may not use the Code.
SAS and all other SAS Institute Inc. product or service names
are registered trademarks or trademarks of SAS Institute Inc. in the USA and
other countries. (r) indicates USA registration. Other brand and product names
are registered trademarks or trademarks of their respective companies. */
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-07-13 15:04:27 |
| Date Created: | 2008-05-02 16:19:47 |